CREATE VIEW BAKIYEKAPANMAMIS AS (
SELECT     dbo.ACTTRANS.TRANSDATE, dbo.ACTTRANS.ITEMNO AS TRANSITEMNO, dbo.ACTTRANS.DUEDATE, dbo.ACTTRANS.ROOT, dbo.ACTTRANS.ROOTID AS RECEIPTID, 
                      dbo.ACTTRANS.ROOTRECEIPTNO AS RECEIPTNO, dbo.ACTTRANS.ROOTRECEIPTITEMNO AS ITEMNO, dbo.ACTTRANS.ROOTID, dbo.ACTTRANS.CURRCODE, 
                      dbo.ACTTRANS.CURREXC, SUM(ISNULL(dbo.ACTTRANS.DEBIT, 0) + ISNULL(dbo.ACTTRANS.CREDIT, 0) - ISNULL(dbo.ACTTRANS.PAYMENTTOTAL, 0)) AS TOTAL, 
                      SUM(ISNULL(dbo.ACTTRANS.CURRDEBIT, 0) + ISNULL(dbo.ACTTRANS.CURRCREDIT, 0) - ISNULL(dbo.ACTTRANS.PAYMENTCURRTOTAL, 0)) AS CURRTOTAL, 
                      dbo.ACT.ACTNO, dbo.ACT.ACTNAME, dbo.ACT.ACTID, dbo.ACTTRANS.COMPANYID, dbo.ACTTRANS.CPERIODID, dbo.ACTTRANS.DEBIT, dbo.ACTTRANS.CREDIT, 
                      dbo.ACTTRANS.PAYMENTTOTAL, dbo.ACTTRANS.PAYMENTCURRCODE, dbo.ACTTRANS.PAYMENTCURRTOTAL, dbo.ACTTRANS.CURRDEBIT, 
                      dbo.ACTTRANS.CURRCREDIT, dbo.ACTTRANS.CURRDEBITTRANS, dbo.ACTTRANS.CURRCREDITTRANS, dbo.ACTTRANS.CURRDATE, 
                      dbo.ACTTRANS.CURRCODETRANS, dbo.ACTTRANS.CURRDATETRANS, dbo.ACTTRANS.CURREXCTRANS, dbo.ACTTRANS.CASHID, dbo.ACTTRANS.BANKID, 
                      dbo.ACTTRANS.EXPREVID, dbo.ACTTRANS.DUEDAY, dbo.ACTTRANS.DUEOPSDATE, dbo.ACTTRANS.RECEIPTTYPE, dbo.ACTTRANS.DESCRIPTION, 
                      dbo.ACTTRANS.TRANSTYPE
FROM         dbo.ACTTRANS INNER JOIN
                      dbo.ACT ON dbo.ACTTRANS.COMPANYID = dbo.ACT.COMPANYID AND dbo.ACTTRANS.ACTID = dbo.ACT.ACTID
GROUP BY dbo.ACTTRANS.TRANSDATE, dbo.ACTTRANS.ITEMNO, dbo.ACTTRANS.DUEDATE, dbo.ACTTRANS.ROOT, dbo.ACTTRANS.ROOTID, dbo.ACTTRANS.ROOTRECEIPTNO, 
                      dbo.ACTTRANS.ROOTRECEIPTITEMNO, dbo.ACTTRANS.CURRCODE, dbo.ACTTRANS.CURREXC, dbo.ACT.ACTNO, dbo.ACT.ACTNAME, dbo.ACT.ACTID, 
                      dbo.ACTTRANS.COMPANYID, dbo.ACTTRANS.CPERIODID, dbo.ACTTRANS.DEBIT, dbo.ACTTRANS.CREDIT, dbo.ACTTRANS.PAYMENTTOTAL, 
                      dbo.ACTTRANS.PAYMENTCURRCODE, dbo.ACTTRANS.PAYMENTCURRTOTAL, dbo.ACTTRANS.CURRDEBIT, dbo.ACTTRANS.CURRCREDIT, 
                      dbo.ACTTRANS.CURRDEBITTRANS, dbo.ACTTRANS.CURRCREDITTRANS, dbo.ACTTRANS.CURRDATE, dbo.ACTTRANS.CURRCODETRANS, 
                      dbo.ACTTRANS.CURRDATETRANS, dbo.ACTTRANS.CURREXCTRANS, dbo.ACTTRANS.CASHID, dbo.ACTTRANS.BANKID, dbo.ACTTRANS.EXPREVID, 
                      dbo.ACTTRANS.DUEDAY, dbo.ACTTRANS.DUEOPSDATE, dbo.ACTTRANS.RECEIPTTYPE, dbo.ACTTRANS.DESCRIPTION, dbo.ACTTRANS.TRANSTYPE
HAVING      (SUM(ISNULL(dbo.ACTTRANS.DEBIT, 0) - ISNULL(dbo.ACTTRANS.PAYMENTTOTAL, 0)) > 0.1))